CREATE PROCEDURE [dbo].[TempUpdateSysConfig] @ParameterName nvarchar(255), @ParameterDescription nvarchar(500), @SortOrder int, @FieldLength int = 0 AS
BEGIN
    UPDATE SystemConfigParameterRef SET Description = @ParameterDescription WHERE ParameterName = @ParameterName
    UPDATE SystemConfigPageParameterRef SET SortOrder = @SortOrder WHERE ParameterName = @ParameterName

    IF @FieldLength > 0
        UPDATE a
           SET HIControlWidth = @FieldLength
          FROM PropertyDefinition a inner join SystemConfigParameterRef b on a.PropertyDefinitionKey = b.PropertyDefinitionKey
         WHERE b.ParameterName = @ParameterName
END

GO